package com.vipymh.springbootmybatisdemo.mapper;

import com.vipymh.springbootmybatisdemo.pojo.Article;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ArticleMapper {

    // 新增
    @Insert("insert into article (title,content,cover_img,state,category_id,create_user,create_time,update_time) " +
            "values (#{title},#{content},#{coverImg},#{state},#{categoryId},#{createUser},#{createTime},#{updateTime})")
    void add(Article article);

    // 条件分页查询
    // 动态参数 推荐采用映射注解方式处理
    List<Article> list(Integer userId, Integer categoryId, String state);
}
